package com.changgou.goods.dao;

import com.changgou.goods.pojo.Brand;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;
import java.util.Map;

/**
 * @author caixiaofeng
 * @company xxx公司科技有限公司
 * @create 2020-04-28 11:20
 */
public interface BrandMapper extends Mapper<Brand> {

    @Select("SELECT name,image FROM tb_brand WHERE id IN (SELECT\n" +
            "brand_id FROM tb_category_brand WHERE category_id IN (SELECT id FROM\n" +
            "tb_category WHERE NAME=#{name}) )order by seq")
    List<Map>findListByCategoryName(@Param("name")String categoryName);

}
